Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SGA_RESIZE_OPS

`V$SGA_RESIZE_OPS` displays information about the last 800 completed SGA resize operations. This does not include in-progress operations. All sizes are expressed in bytes.

Column | Datatype | Description
--- | --- | ---
`COMPONENT` | `VARCHAR2(64)` | Component name
`OPER_TYPE` | `VARCHAR2(13)` | Operation type: `STATIC` `INITIALIZING` `DISABLED` `GROW` `SHRINK` `SHRINK_CANCEL`
`OPER_MODE` | `VARCHAR2(9)` | Operation mode: `MANUAL` `DEFERRED` `IMMEDIATE`
`PARAMETER` | `VARCHAR2(80)` | Name of the parameter for the resize operation
`INITIAL_SIZE` | `NUMBER` | Parameter value at the start of the operation
`TARGET_SIZE` | `NUMBER` | Requested value of the parameter after the resize
`FINAL_SIZE` | `NUMBER` | Real value of the parameter after the resize
`STATUS` | `VARCHAR2(9)` | Completion status of the operation: `INACTIVE` `PENDING` `COMPLETE` `CANCELLED` `ERROR`
`START_TIME` | `DATE` | Start time of the operation
`END_TIME` | `DATE` | End time of the operation